SSRS 2008 configuration Manager - "Invalid Class"
Reporting Services Configuration Manager is throwing an error when I try to "Find" the server. The manager starts up and takes me to the "Reporting Services Configuration Connection" window. I click on the "Find" button (leaving the default comptuer name as-is; the local machine) and get the error message "Invalid Class" with the title "Reporting Services Configuration Manager". I've been searching around the interner and only found one forum post with a similar problem to my own. It was on this forum and the advice seemed to be pointing towards a problem with WMI, but it seemed that the user never found a solution. I've downloaded and ran the WMI diagnostics program and the log does contain quite a few warnings, but I don't know how to go about solving most of them. I did run regsvr32 on some dll files though :) I won't post any logs yet, as I have no idea where the problem may be based. Please advise and I will post the required information.
January 18th, 2010 4:10pm
This is a common problem with you install 2005 and 2008 on the same server. Is SSRS 2008 the only installation that is currently installed?Ted Krueger
Blog on lessthandot.com
@onpnt on twitter
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2010 4:28pm
Nope, I do have 2005 installed aswell. I suppose I don't actually need them both installed though... It just taken me a while to get the two versions that I'm not sure about playing with the installations. hehe If I were to remove 2005, would it require me to remove the entire installation of SQL Server 2005 or just the SSRS part of it? Also, do you happen to know if removing 2005 (be it the entire thing or just SSRS) would solve the problem without me needing to manually edit config files etc? Thanks for the response onpnt
January 18th, 2010 4:39pm
Hi, I have SSRS 2005 AND SSRS 2008 installed on the same server, but I never faced that problem.Not sure having both version installed is linked to that issue.Amaury.
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2010 4:43pm
Not sure having both version installed is linked to that issue.
You never know Amaury - I'm sure that SQL Server and SSRS have lots of settings and certain things may only be changed under certain circumstances.
January 18th, 2010 5:53pm
That's why I wrote "Not Sure" ;-)
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2010 6:17pm
Hi SiM99,The issue shoule be caused by the case onpnt mentioned and you are trying to use Reporting Services Configuration Manager 2008 to connect to Reporting Services 2005. From your post, I am sure you never install SQL Server 2005 in the server. But, sometimes, SQL Server Express 2005 may be installed with other program. So, I would suggest you checking if SQL Server Expree 2005 is installed in the server using Services control(by running command services.msc). If SQL Server Express 2005 is installed, please uninstall it.The issue should be caused by the uncompleted installation too. There may be a error during the installation.Could you please check if there is any error in the installation error message?By default, we can get the installation logs from:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Summary.txtBy the way, could you please follow these steps to check if the Reporting Services WMI provider is installed correctly?1. Run command wbemtest2. Click "Connect"and connect to “ROOT\Microsoft\SqlServer\ReportServer”(type this path in the Namespace textbox)3. After connecting to the name space, click "Query" to query “SELECT * from __namespace”. There would be one data in the record window(while the server only have one RS instance).4. Double-click the record, in the new properties windows, get the path value such as “\\<server>\ROOT\Microsoft\SqlServer\ReportServer:__NAMESPACE.Name="RS_MSSQLSERVER" ”5. Now, close all sub dialogs, and then re-connect to “ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER”. "RS_MSSQLSERVER" is the Namespace.Name in step46. Query “SELECT * from __namespace” again. 7. Repeat step4,5, we will get the new path “ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10”8. Repeat step2 to 7 until there is no record in the Query result dialog. Finally, the path is \\server\ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\adminIf we can't get the final path \\server\ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin, it means the Reporting Services WMI provider is not installed correctly.Please try using the following method to solve it:1.Execute the Command windows.2.Go to the folder C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin3.Run the command: MOFCOMP reportingservices.mofPlease feel free to ask, if you have any more questions.Thanks,Jin ChenJin Chen - MSFT
January 20th, 2010 12:23pm
Installing SP1 would resolve the issue.
Free Windows Admin Tool Kit Click here and download it now
October 1st, 2010 5:06pm
Hi,
Install SP1 in the sense of SQL server 2008 SP1?
Regards, R@J
October 7th, 2010 6:57am